home *** CD-ROM | disk | FTP | other *** search
- OPA A E╔═╦═╗ ╔═╦═╗F
- P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F
- P E╚═╩═╝ ╚═╩═╝F
-
- P E┌──────────────────┐F
- P E│COURSE INFORMATION│F
- P E└──────────────────┘F
-
- P EThe information that follows in this course is designed toF
- P Etake the student through the steps necessary to become anF
- P Eefficient user of dBase IV in the shortest possible time. dBaseF
- P EIV is a new system for creating and maintaining databases. It hasF
- P Eits roots in earlier versions of dBase and much of it will beF
- P Efamiliar to those who already know one of the previous versions.F
-
- P EThe materials presented in DESIGNING DATABASES WITH DBASE IVF
- P Eare designed for managers and first-time system designers. In itF
- P Eis taught the concepts of systems analysis and design and the useF
- P Eof the Control Center to create complete systems withoutF
- P Eprogramming. ADVANCED DATABASE DESIGN WITH DBASE IV is designedF
- P Efor those who have mastered the implementation of simple systemsF
- P Eand wish to build relational systems including SQL and customF
- P EdBase coding. There is emphasis on the Developer's EditionF
- P Efeatures and usage.F
-
- P EThese courses are designed to be taught in both hands-on andF
- P Electure formats. In the lecture format the course will be taughtF
- P Ein 2 days. In the hands on format it will be taught in 5 days.F
- P EThe additional time for the hands-on students will allow ampleF
- P Epractice problems to master the use of dBase IV before the end ofF
- P Einstruction.F
-
- P EThe data diskette contains the files used during thisF
- P Ecourse. All examples shown during the course can be recreated atF
- P Ea later time using these files. LOG to Drive A: and enterF
- P EINSTALL.F
-
- P ELicenses for the use of the course materials for trainingF
- P Ewithin your company or organization are available from theF
- P Esponsors of this seminar. Please contact them for additionalF
- P Einformation.F
-
- P EThese course materials including Manuals, Diskettes andF
- P EHandouts were written by Bruce Troutman and are owned andF
- P Ecopyrighted by:F
-
- P EInterco International, LtdF
- P E1170 Weldstone CourtF
- P EAtlanta, GA 30305F
- P EUSAF
-
- P E(404) 392-0184F
-
- P ELicences are granted for the personal use of students whoF
- P Eattend courses offered by an authorized training facility. NoF
- P Ereproduction or other use of the materials may be made withoutF
- P Ethe written consent of Interco International, Ltd. dBASE IV is aF
- P Etrademark of Ashton-Tate.
- PEA A ╔═╦═╗ ╔═╦═╗F
- P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F
- P E╚═╩═╝ ╚═╩═╝F
-
- P E╔═══════════════════╗F
- P E║ TABLE OF CONTENTS ║F
- P E╚═══════════════════╝F
-
-
- P EADVANCED TECHNIQUES AND PROGRAMMINGF
-
- P EADVANCED QUERIES AND RELATED FILESF
-
- P EAd Hoc Inquiries - Find only what you want 3F
- P EUsing Query By Example - Examples 1-7 4F
- P EMultiple File Links - Examples 8-13 11F
- P EUpdates - Examples 14-15 18F
-
- P EMULTIPLE FILE REPORT CREATIONF
-
- P ECustom Report Design 19F
- P EGrouping 19F
- P EWorking with Bands 19F
- P ETitle 19F
- P EHeader 19F
- P EBody 19F
- P EFooter 20F
- P ESummary 20F
- P EExamples 21F
-
- P EDATA VALIDATIONF
-
- P EDefinition 32F
- P EImportant Note on Multiple Files 33F
- P EExample using TIME.DBF 34F
-
- P EPRINCIPLES OF GOOD PROGRAMMINGF
-
- P ESpeed vs. Cost vs. Maintenance Decisions 37F
- P EThe Golden Rule 38F
- P EDocumentation 38F
- P EDevelopment of Systems with Developer's Edition 41F
-
- P EPROGRAMMING WINDOWS AND MENUSF
-
- P ECUSTOMER MENU Example 42F
- P ECUSTOMER MENU Code 51F
- P EJOB COST Example 52F
- P EAPGEN Summary 58
- PEA A ╔═╦═╗ ╔═╦═╗F
- P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F
- P E╚═╩═╝ ╚═╩═╝F
-
- P EPROGRAMMING TOOLS, DATA TRANSFERS AND SQLF
-
- P EPROGRAMMING UTILITIESF
-
- P EAutomatic Compiling to Encode and Speed Programs 59F
- P ERuntime for Royalty Free Distribution 61F
- P EThe Editor - Enhanced Support for Programming 63F
- P EThe Debugger - Professional Support 66F
- P EStep IVward - Conversion Utility 67F
-
- P EPROGRAMMING FOR NETWORKSF
-
- P EInstallation 70F
- P EProtect 71F
- P ELocking TechniquesF
- P EAutolock Features 73F
- P EManual Locking Consideration 73F
- P EScreen Refresh 73F
- P ETransaction Processing 73F
- P ETRANPROC.PRG Example 74F
-
- P EDATA TRANSFER TECHNIQUESF
-
- P EConcepts of COPY and APPEND 75F
- P ETo and FromF
- P ELotus 123, Word Processors,Mainframes,F
- P EMinicomputers,ASCII,DIF,SYLK 76F
- P EAppending from a Fixed-Length Text File 78F
- P EdBASE DIRECTF
- P EDirect Manipulation of Minicomputer Data 78F
-
- P ESQL - STRUCTURED QUERY LANGUAGEF
-
- P EDefinitions 79F
- P EData Types 79F
- P ESQL Commands 80F
- P ESQL and dBASE IV Programming 82F
-
- P EIMPORTANT NEW COMMANDS AND FUNCTIONSF
-
- P ECommands 84F
- P ESet Commands 86F
- P EFunctions 88F
- P ESystem Variables 91F
-
- P ECONSIDERATIONS FOR THE FUTUREF
-
- P EOperating Systems: DOS 4.0 OS/2 92F
- P ELocal Area Network Technology 92F
- P EServer Technology 92
- PEA A ╔═╦═╗ ╔═╦═╗F
- P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F
- P E╚═╩═╝ ╚═╩═╝F
-
- P ECOURSE SUMMARY 94F
-
- P ECOURSE EXAMPLE PROBLEMS 95F
-
- P EREFERENCEF
- P EFunction Keys 97F
- P EFile Extensions 98F
- P EFile Structures 99F
-
- P EEXTRA WORKSHEETSF
-
- P EINDEX
- PEA A ╔═╦═╗ ╔═╦═╗F
- P E╠═╬═╣ ADVANCED DATABASE DESIGN WITH dBASE IV ╠═╬═╣F
- P E╚═╩═╝ ╚═╩═╝
- @
